package org.androidpn.constant;

public class Constant {
	public static String CREATETABLERECEIVE_INFO="create table RECEIVE_INFO" +
			"(title TEXT,date TEXT,msg TEXT,uri TEXT,id INTEGER PRIMARY KEY AUTOINCREMENT)";
	public static String CREATETABLERUBISH_INFO="create table RUBISH_INFO" +
			"(title TEXT,date TEXT,msg TEXT,uri TEXT,id INTEGER PRIMARY KEY)";
	public static String CREATETABLEFAVOURITE_INFO="create table FAVOURITE_INFO" +
			"(title TEXT,date TEXT,msg TEXT,uri TEXT,id INTEGER PRIMARY KEY)";
	public static String CREATETRIGGER_DELETE="create trigger TRIGGER_DELTE before delete on RECEIVE_INFO for each row begin insert into RUBISH_INFO(title,date,msg,uri,id) values(old.title,old.date,old.msg,old.uri,old.id);end;";
	public static String URI="http://10.200.254.68:8080/";
	public static String URL_PATH="http://10.200.254.68:8080/test/test.jsp";
	public static String RECEIVE_TABLE="RECEIVE_INFO";
	public static String RUBISH_TABLE="RUBISH_INFO";
	public static String FAVOURITE_TABLE="FAVOURITE_INFO";
}
